5-E
Simple site for the info you need...
  • Add Local Admin
  • Backup Dogecoin Wallet
  • Batch Start Powershell
  • Copy A File(s) To All Users On A PC
  • CPU Load Test
  • Disable Users
  • Email Group Members
  • Email With Powershell
  • Exchange Total Size
  • Export to XLSX
  • Export User Cert
  • Get System Info
  • Import Active Directory Module
  • Last Login For All Computer
  • Last Login For All Users
  • Last Login For Select Users
  • List Domain controllers
  • List Groups (With Count) In Active Directory To TXT
  • List Groups (With Count) In Active Directory To XLSX
  • List Groups For A User(s)
  • List Groups In Active Directory to TXT
  • List Home Directory
  • List Members In A Group(s)
  • Password Generator
  • Ping Test
  • Printer Reset
  • Run A Process Every Few Minutes
  • Search For Files On All Local Drives
  • Show iSCSI Device And Disk Number
  • Uninstall Java

Powershell Export To XLSX

This is a basic example of using Powershell to export results to XLSX.
CODE:
$r1c1 = "This is row1 column1" 
$r1c2 = "This is row1 column2" 
$r2c1 = "This is row2 column1" 
$r2c2 = "This is row2 column2" 
#create Excel Workbook 
$Excel = New-Object -Com Excel.Application  
$Excel.visible = $True  
$Excel = $Excel.Workbooks.Add()  
$wSheet = $Excel.Worksheets.Item(1)  
$wSheet.Cells.item(1,1) = "Column1:"  
$wSheet.Cells.Item(1,2) = "Column2:"  
$WorkBook = $wSheet.UsedRange  
$WorkBook.Interior.ColorIndex = 45  
$WorkBook.Font.ColorIndex = 1  
$WorkBook.Font.Bold = $True  
$intRow = 1 
$intRow++ 
$wSheet.Cells.item($intRow,1) = $r1c1 
$wSheet.Cells.Item($intRow,2) = $r1c2 
$intRow++ 
$wSheet.Cells.item($intRow,1) = $r2c1 
$wSheet.Cells.Item($intRow,2) = $r2c2 
Use at your own risk
Download: Export to XLSX.zip

Tag(s): How To Powershell


Could you spare a few coins?
Dogecoin - D838u1m9YRdzVVu8CZ1JsR78WHgQmUZSr8
Bitcoin - 13iKLoPXcWEYcGtqCi4UcjGQEs7r6M6LFc
Thank you
  • Home

  • Batch
  • Email
  • Exchange
  • How To
  • Local PC
  • Powershell
  • Security